
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from pandas import Series
import seaborn as sns
import datetime
import random
pd.set_option("display.max_columns",None) #show all columns
pd.set_option("display.max_rows",None) #show all rows


#import data into two table
#data 1 is Claimant_final
#data 2 is Claim_final
data_1 = pd.read_csv("Claim_final.csv")# ,encoding = "utf-8")
data_2 = pd.read_csv("Claimant_final.csv")#encoding ="utf-8")
data = data_1.merge(data_2)
data = pd.DataFrame(data)
data.drop(["CLM_NBR","POL_NBR","VEH_COLR_TXT"],axis = 1)
data


data["COV_RGST_DT"] = pd.to_datetime(data["COV_RGST_DT"])
data["PRI_BTH_DT"] = pd.to_datetime(data["PRI_BTH_DT"]) # convertion of time frame
print(type(data["COV_RGST_DT"]))# still in series 
print(type(data["PRI_BTH_DT"]))
data["age"]= data["COV_RGST_DT"].dt.year - data["PRI_BTH_DT"].dt.year
#data = pd.DataFrame(data)
data

<class 'pandas.core.series.Series'>
<class 'pandas.core.series.Series'>


data = data.drop(data[data["age"] > 14].index)
data


closed_without_pay = data[data["CLAIMANT_STATUS"] =="Closed without Payment"]
closed_without_pay.count()

Unnamed: 0                  16
CLM_NBR                     16
NBR_OF_CLMT                 16
BI_CLMT_CNT                 16
COV_RGST_DT                 16
CLAIM_EXPENSE_EST_AMT       16
CLAIM_INDEMNITY_EST_AMT     16
POL_NBR                     16
POLICY_STATE                16
PRI_BTH_DT                  16
AUTO_ACCIDENT_DESC          16
CLAIMANT_STATUS             16
APPR_DAM_EST_REC_CNT        16
VEH_COLR_TXT                16
VEH_DAM_TXT                 16
CLMT_VEH_MDL_NM             16
CLMT_VEH_YR                 16
VEH_TYPE                    16
VEH_PRIMARY_PT_OF_DAMAGE    16
AIRBAG_DEPLOYED             16
VEH_SPEED_AT_IMPACT         16
age                         16
dtype: int64


closed_with_pay = data[data["CLAIMANT_STATUS"] =="Closed with Payment"]
closed_with_pay.count()

Unnamed: 0                  50
CLM_NBR                     50
NBR_OF_CLMT                 50
BI_CLMT_CNT                 50
COV_RGST_DT                 50
CLAIM_EXPENSE_EST_AMT       50
CLAIM_INDEMNITY_EST_AMT     50
POL_NBR                     50
POLICY_STATE                50
PRI_BTH_DT                  50
AUTO_ACCIDENT_DESC          50
CLAIMANT_STATUS             50
APPR_DAM_EST_REC_CNT        50
VEH_COLR_TXT                50
VEH_DAM_TXT                 50
CLMT_VEH_MDL_NM             50
CLMT_VEH_YR                 50
VEH_TYPE                    50
VEH_PRIMARY_PT_OF_DAMAGE    50
AIRBAG_DEPLOYED             50
VEH_SPEED_AT_IMPACT         50
age                         50
dtype: int64


young_age = data[data["age"] < 14]
young_age


closed_without_pay = data[data["CLAIMANT_STATUS"] =="Closed without Payment"]
closed_without_pay


saved_money1 = data["CLAIM_INDEMNITY_EST_AMT"]
li = []
def money(saved_money1):
    for x in saved_money1:
        if x != 0:
            li.append(x)
    return sum(li)
print(money(saved_money1))

1866483


old_age =  data[data["age"] > 14].count()
old_age

Unnamed: 0                  1506
CLM_NBR                     1506
NBR_OF_CLMT                 1506
BI_CLMT_CNT                 1506
COV_RGST_DT                 1506
CLAIM_EXPENSE_EST_AMT       1492
CLAIM_INDEMNITY_EST_AMT     1506
POL_NBR                     1506
POLICY_STATE                1488
PRI_BTH_DT                  1506
AUTO_ACCIDENT_DESC          1506
CLAIMANT_STATUS             1506
APPR_DAM_EST_REC_CNT        1506
VEH_COLR_TXT                1492
VEH_DAM_TXT                 1506
CLMT_VEH_MDL_NM             1506
CLMT_VEH_YR                 1506
VEH_TYPE                    1506
VEH_PRIMARY_PT_OF_DAMAGE    1506
AIRBAG_DEPLOYED             1506
VEH_SPEED_AT_IMPACT         1506
age                         1506
dtype: int64


y = np.array([58,1506])

plt.pie(y,
        labels=["age under 14", "age above 14"], 
        colors=["#d5695d", "#5d8ca8"], 
        explode=(0, 0), 
        autopct='%.2f%%', 
       )
plt.title("age distribution")
plt.show()


closed_with_pay = data[data["CLAIMANT_STATUS"] =="Closed with Payment"]
closed_with_pay.count()

Unnamed: 0                  1121
CLM_NBR                     1121
NBR_OF_CLMT                 1121
BI_CLMT_CNT                 1121
COV_RGST_DT                 1121
CLAIM_EXPENSE_EST_AMT       1111
CLAIM_INDEMNITY_EST_AMT     1121
POL_NBR                     1121
POLICY_STATE                1108
PRI_BTH_DT                  1121
AUTO_ACCIDENT_DESC          1121
CLAIMANT_STATUS             1121
APPR_DAM_EST_REC_CNT        1121
VEH_COLR_TXT                1110
VEH_DAM_TXT                 1121
CLMT_VEH_MDL_NM             1121
CLMT_VEH_YR                 1121
VEH_TYPE                    1121
VEH_PRIMARY_PT_OF_DAMAGE    1121
AIRBAG_DEPLOYED             1121
VEH_SPEED_AT_IMPACT         1121
age                         1121
dtype: int64


y = np.array([392,1121])

plt.pie(y,
        labels=["Closed without Payment", "Closed with Payment"], 
        colors=["#d5695d", "#5d8ca8"], 
        explode=(0, 0), 
        autopct='%.2f%%', 
       )
plt.title("age above 14")
plt.show()


data = data.drop(data[data["age"] > 14].index)
data


y = np.array([16,52])

plt.pie(y,
        labels=["Closed without Payment", "Closed with Payment"], 
        colors=["#d5695d", "#5d8ca8"], 
        explode=(0, 0), 
        autopct='%.2f%%', 
       )
plt.title("age under 14")
plt.show()


age = data["age"]
# 将ages列表转换成pandas的Series对象
age_series = pd.Series(age)

# 使用pandas的value_counts()方法统计每个年龄出现的次数
age_counts = age_series.value_counts().sort_index()

# 绘制折线图
plt.plot(age_counts.index, age_counts.values, '-o')
plt.xlabel('Age')
plt.ylabel('Count')
plt.title('Age Distribution')
plt.show()


state = data["POLICY_STATE"]
state_series = pd.Series(state)
plt.figure(figsize=(20,5))
state_counts = state_series.value_counts().sort_index()
plt.plot(state_counts.index, state_counts.values, '-o')
plt.xlabel("state")
plt.ylabel("Count")
plt.title("State Distribution")
plt.show()


#loc all the info with age below 14; check if age 14 with payment status
young_kid = data[data["age"] < 14]
young_kid


car_year = data["CLMT_VEH_YR"]
car_year_series = pd.Series(car_year)
plt.figure(figsize=(20,5))
car_year_counts = car_year_series.value_counts().sort_index()
plt.plot(car_year_counts.index, car_year_counts.values, '-o')
plt.xlabel("car year")
plt.ylabel("Count")
plt.title("car year Distribution")
plt.show()


#count how many money we can save for the insurance business
saved_money1 = data["age"]
li = []
def money(saved_money1):
    for x in saved_money1:
        if x != 0:
            li.append(x)
    return sum(li)
print(money(saved_money1))

67413


#1. STEP ONE: delete all the under age, in a eazy way, we suppose 14 here
data = data.drop(data[data["age"] < 14].index)
data


#check the liability 
#clear_liability = data[data["AUTO_ACCIDENT_DESC"] == "Multi Veh - Clear Liab"]
#clear_liability
#车的事故判定和检查次的关系
x = data["AUTO_ACCIDENT_DESC"]
y = data["APPR_DAM_EST_REC_CNT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#车的事故判定和赔偿金额的关系
x = data["AUTO_ACCIDENT_DESC"]
y = data["CLAIM_INDEMNITY_EST_AMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#claimants 和body injury的对比图
x = data["NBR_OF_CLMT"]
y = data["BI_CLMT_CNT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#调查费用和需要pay的费用
x = data["CLAIM_EXPENSE_EST_AMT"]
y = data["CLAIM_INDEMNITY_EST_AMT"]
sns.stripplot(y,x,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#Claimant 支付费用
x = data["NBR_OF_CLMT"]
y = data["CLAIM_INDEMNITY_EST_AMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#body injury人数 与支付费用
x = data["BI_CLMT_CNT"]
y = data["CLAIM_INDEMNITY_EST_AMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#Claimant 与调查费用
x = data["NBR_OF_CLMT"]
y = data["CLAIM_EXPENSE_EST_AMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#Claimant和调查费用
x = data["BI_CLMT_CNT"]
y = data["CLAIM_EXPENSE_EST_AMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#事故状态 与 调查次数；
x = data["AUTO_ACCIDENT_DESC"]
y = data["APPR_DAM_EST_REC_CNT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#事故状态 claiments
x = data["AUTO_ACCIDENT_DESC"]
y = data["NBR_OF_CLMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#事故状态 body injury
x = data["AUTO_ACCIDENT_DESC"]
y = data["BI_CLMT_CNT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#事故状态 需要支付的费用
x = data["AUTO_ACCIDENT_DESC"]
y = data["CLAIM_INDEMNITY_EST_AMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#事故状态和调查费用
x = data["AUTO_ACCIDENT_DESC"]
y = data["CLAIM_EXPENSE_EST_AMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#事故状态和车检查次数
x = data["AUTO_ACCIDENT_DESC"]
y = data["CLAIM_EXPENSE_EST_AMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#事故状态和撞车状态
x = data["AUTO_ACCIDENT_DESC"]
y = data["VEH_SPEED_AT_IMPACT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#事故状态和气囊展开个数
x = data["AUTO_ACCIDENT_DESC"]
y = data["NBR_OF_CLMT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#调查费用和调查次数
x = data["CLAIM_EXPENSE_EST_AMT"]
y = data["APPR_DAM_EST_REC_CNT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#支付费用和调查次数
x = data["CLAIM_INDEMNITY_EST_AMT"]
y = data["APPR_DAM_EST_REC_CNT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#调查费用和气囊个数
x = data["CLAIM_EXPENSE_EST_AMT"]
y = data["APPR_DAM_EST_REC_CNT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#支付费用和气囊个数
x = data["CLAIM_INDEMNITY_EST_AMT"]
y = data["AIRBAG_DEPLOYED"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#调查费用和撞车姿态
x = data["CLAIM_EXPENSE_EST_AMT"]
y = data["VEH_SPEED_AT_IMPACT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#支付费用和撞车姿态
x = data["CLAIM_INDEMNITY_EST_AMT"]
y = data["VEH_SPEED_AT_IMPACT"]
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#STEP 2: delete all the clear liablity, we suppose the clear liability means all clear with 100% confidence 
data = data.drop(data[data["AUTO_ACCIDENT_DESC"] == "Multi Veh - Clear Liab"].index)
data


length = len(data)
print(length)

1480


#check the type of veh_type. and identify the veh_type if related to fraud
car_type = data["VEH_TYPE"].value_counts()[:10]
print(car_type)

Automobile        1479
Specialty Auto       1
Name: VEH_TYPE, dtype: int64


# case number too small, can not use
car_special = data[data["VEH_TYPE"] == "Specialty Auto"]
car_special


#check the data with NBR_OF_CLMT, BI_CLMT_CNT, APPR_DAM_EST_REC_CNT, VEH_PRIMARY_PT_OF_DAMAGE, AIRBAG_DEPLOYED, VEH_SPEED_AT_IMPACT
data = pd.DataFrame(data,columns = ["NBR_OF_CLMT", "BI_CLMT_CNT", "APPR_DAM_EST_REC_CNT", "VEH_PRIMARY_PT_OF_DAMAGE", "AIRBAG_DEPLOYED", "VEH_SPEED_AT_IMPACT"])
data


# scatterplot 1 for x-axis numb of people and y-axis numb of airbag deployed
x = data["NBR_OF_CLMT"]
y = data["AIRBAG_DEPLOYED"]
plt.title("The relationship between number of people and number of airbag deployed")
plt.ylabel("number of claiments", fontsize = 10, color = "r")
plt.xlabel("number of airbag deployed",fontsize = 10, color = "r")
#plt.scatter(y,x,s=30,alpha = 0.2)
sns.stripplot(y,x,jitter=True, color ="b",s =10, alpha = 0.1)

x = data["AIRBAG_DEPLOYED"]
y = data["VEH_SPEED_AT_IMPACT"]

plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#scatterplot 2 for speed and airbag deployed. 
x = data["AIRBAG_DEPLOYED"]
y = data["VEH_SPEED_AT_IMPACT"]

plt.title("The relationship between the speed at impact and number of airbag deployed", color = "r")
plt.ylabel("speed at impact", fontsize = 10, color = "r")
plt.xlabel("number of airbag deployed",fontsize = 10, color = "r")
#plt.scatter(x,y,alpha = 0.1)
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


#part 1
x = data["NBR_OF_CLMT"]
y = data["AIRBAG_DEPLOYED"]
plt.title("The relationship between number of people and number of airbag deployed")
plt.ylabel("number of claiments", fontsize = 10, color = "r")
plt.xlabel("number of airbag deployed",fontsize = 10, color = "r")
#plt.scatter(y,x,s=30,alpha = 0.2)
sns.stripplot(y,x,jitter=True, color ="b",s =10, alpha = 0.1)

x = data["AIRBAG_DEPLOYED"]
y = data["VEH_SPEED_AT_IMPACT"]

x = data["AIRBAG_DEPLOYED"]
y = data["VEH_SPEED_AT_IMPACT"]

#part2
plt.title("The relationship between the speed at impact and number of airbag deployed", color = "r")
plt.ylabel("speed at impact", fontsize = 10, color = "r")
plt.xlabel("number of airbag deployed",fontsize = 10, color = "r")
#plt.scatter(x,y,alpha = 0.1)
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(
/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


# the relationship bw the number of airbag deployed and year of the car 
x = data["AIRBAG_DEPLOYED"]
y = data["CLMT_VEH_YR"]
plt.title("The relationship between the year of car and number of airbag deployed", color = "r")
plt.ylabel("year of car", fontsize = 10, color = "r")
plt.xlabel("number of airbag deployed",fontsize = 10, color = "r")
#plt.scatter(x,y,alpha = 0.1)
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


x = data["VEH_SPEED_AT_IMPACT"]
y = data["VEH_PRIMARY_PT_OF_DAMAGE"]

#plt.scatter(x,y,alpha = 0.1)
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(


x = data["AIRBAG_DEPLOYED"]
y = data["VEH_PRIMARY_PT_OF_DAMAGE"]

#plt.scatter(x,y,alpha = 0.1)
sns.stripplot(x,y,jitter=True,color = "r",s = 10,alpha = 0.1)
plt.show()

/Users/chenghaolou/opt/anaconda3/lib/python3.9/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(

	Unnamed: 0	CLM_NBR	NBR_OF_CLMT	BI_CLMT_CNT	COV_RGST_DT	CLAIM_EXPENSE_EST_AMT	CLAIM_INDEMNITY_EST_AMT	POL_NBR	POLICY_STATE	PRI_BTH_DT	AUTO_ACCIDENT_DESC	CLAIMANT_STATUS	APPR_DAM_EST_REC_CNT	VEH_COLR_TXT	VEH_DAM_TXT	CLMT_VEH_MDL_NM	CLMT_VEH_YR	VEH_TYPE	VEH_PRIMARY_PT_OF_DAMAGE	AIRBAG_DEPLOYED	VEH_SPEED_AT_IMPACT	age
6	31	CBH7XVD	1	3	2018-10-15	6286.0	143767	994326201	NC	2007-02-07	Multi Veh - Unclear Liab	Closed with Payment	2	WHITE	BACK GLASS IS OUT -	SRX PREMIU	2016	Automobile	Driver Rear Corner	None	Unknown	11
13	67	A3ROXGM	1	2	2018-04-11	0.0	1985	997059601	MD	2014-12-04	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE ORCHID T	REAR BUMEPR DAMAGE.	ACCORD SPO	2015	Automobile	Complete Rear End	None	Parked or Stopped	4
73	397	9W5RIA4	2	2	2017-06-12	0.0	39454	996619094	FL	2005-09-29	Multi Veh - Unclear Liab	Closed without Payment	1	Blue	F/E BUMPER DMGS	RAM PICKUP	2006	Automobile	Complete Front End	None	Unknown	12
77	416	EZ27RSU	2	5	2018-08-06	2180.0	56082	993611581	FL	2004-08-21	Multi Veh - Unclear Liab	Closed with Payment	2	GOLD	HEAVY F/E DMG, FLUI	ACADIA SLT	2013	Automobile	Complete Front End	None	21-50 mph	14
83	472	E5Q22PP	1	3	2018-12-09	0.0	15721	990580979	TX	2016-04-07	Multi Veh - Unclear Liab	Closed without Payment	0	WHITE	PRIMARY POINT OF DA	SILVERADO	2002	Automobile	Passenger Center	None	Below 10 mph	2
93	532	QAULVZE	4	4	2019-07-05	0.0	13660	996080647	CO	2007-02-11	Multi Veh - Unclear Liab	Closed with Payment	2	WHITE	BACK BUMPER DRAGGIN	EQUINOX LT	2017	Automobile	Complete Rear End	None	Below 10 mph	12
123	649	YB6XOCC	1	1	2018-09-20	0.0	2526	991051544	CO	2010-11-06	Multi Veh - Unclear Liab	Closed with Payment	1	SLATE	NO VISIBLE DMG	TRAVERSE 2	2011	Automobile	Complete Front End	None	Unknown	8
125	660	6QXIUBM	1	2	2016-07-02	0.0	5370	999054715	NC	2006-10-26	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	FRONT END DAMAGES-	EQUINOX LT	2005	Automobile	Complete Front End	None	21-50 mph	10
204	1040	Y6ZIY8Y	1	4	2013-12-26	0.0	4000	994120215	NC	2010-05-04	Multi Veh - Unclear Liab	Closed with Payment	1	RED	POI: P/S F LIGHT BU	ODYSSEY EX	2003	Automobile	Passenger Front Corner	More than one	21-50 mph	3
214	1088	DRSOIBW	1	6	2015-08-19	11006.0	238492	995689563	SC	2007-11-14	Multi Veh - Unclear Liab	Closed without Payment	1	UNKNOWN	POI/DMG UNKNOWN	SL2	2001	Automobile	Driver Front Corner	None	Unknown	8
237	1213	QRY6A0W	1	2	2015-05-20	0.0	232	992280160	NY	2002-12-19	Single Veh	Closed without Payment	0	SILVER	POI: NONE	SEDONA LX/	2006	Automobile	No Damage	None	Parked or Stopped	13
264	1374	SQ9T3EO	1	3	2015-02-23	0.0	8747	998698723	SC	2004-08-18	Multi Veh - Unclear Liab	Closed with Payment	1	CHARCOAL	POI: RR TRUNK PUSHE	CAMARY	2011	Automobile	Complete Rear End	None	21-50 mph	11
339	1719	07ABHRX	1	3	2017-11-08	268.0	110001	995783981	FL	2004-02-17	Multi Veh - Unclear Liab	Closed with Payment	3	BLACK CRYSTAL	DMG TO FRONT END AN	200 LIMITE	2014	Automobile	Complete Front End	None	Below 10 mph	13
340	1725	WUKWJKF	1	4	2014-09-01	0.0	3668	992491005	SC	2000-05-27	Multi Veh - Unclear Liab	Closed with Payment	1	Silver	POI REAR BUMPER SMA	ODYSSEY EX	2010	Automobile	Complete Rear End	None	21-50 mph	14
341	1737	1HKW6LX	3	2	2019-12-30	0.0	10622	997696103	TX	2016-12-11	Multi Veh - Unclear Liab	Closed without Payment	0	GRAY	BUMPER BROKEN	F-150	1995	Automobile	Complete Front End	Unknown	Unknown	3
381	1948	F33UC00	1	3	2017-08-14	12289.0	20986	993709472	NY	2004-11-29	Multi Veh - Unclear Liab	Closed with Payment	2	White	R/E DMG . IV SMOKIN	CAYENNE AW	2014	Automobile	Complete Rear End	Unknown	Unknown	13
386	1973	RQ2PPMI	3	1	2013-11-22	0.0	21358	990788373	VA	1999-11-16	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	UNK DAMAGE	FIVE HUNDR	2005	Automobile	Driver Front Corner	One	Unknown	14
425	2174	5G8AVDW	1	1	2015-10-11	0.0	11769	992490617	TN	2015-10-12	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI: REAR CENTER BA	IMPALA	2012	Automobile	Complete Rear End	None	10-20 mph	0
428	2189	M7NZWRE	1	2	2014-10-24	0.0	4861	991288370	GA	2005-07-18	Multi Veh - Unclear Liab	Closed with Payment	1	GREEN	POI: BUMPER GRILL	CR-V LX	2002	Automobile	Complete Front End	Unknown	Unknown	9
432	2218	DN1HX4Q	2	3	2019-05-26	886.0	28937	997390124	WA	2009-06-03	Multi Veh - Unclear Liab	Closed with Payment	1	BEIGE	COMPLETE FRONT END	SIENNA LE	2011	Automobile	Complete Front End	More than one	10-20 mph	10
455	2378	3NIDUPX	2	4	2018-11-06	0.0	40965	998811319	NC	2009-10-26	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	PRIMARY POINT OF DA	MALIBU LS	2014	Automobile	Complete Front End	None	Unknown	9
466	2461	JF7Q75H	1	6	2018-11-01	0.0	3175	995417981	NC	2007-06-24	Multi Veh - Unclear Liab	Closed with Payment	2	UNKNOWN	REAR UNK	UNKNOWN	2017	Automobile	Complete Rear End	None	Parked or Stopped	11
587	3111	YJ0FH89	1	5	2016-08-18	0.0	551	993538280	MA	2008-06-21	Multi Veh - Unclear Liab	Closed with Payment	2	BLACK	CRUSHED IN PART OF	HIGHLANDER	2007	Automobile	Complete Rear End	None	Parked or Stopped	8
606	3208	4JRAL1K	3	9	2015-08-26	314.0	24032	999538731	SC	2013-06-16	Multi Veh - Unclear Liab	Closed with Payment	2	GREEN	PS FRONT WHEEL PS	CAMRY LE/C	2003	Automobile	Passenger Front Corner	None	Below 10 mph	2
640	3422	RAL8Q00	1	7	2016-03-30	90.0	35812	996422150	IL	2005-04-23	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI: ENTIRE FRONT E	MAZDA2 SPO	2013	Automobile	Complete Front End	More than one	Below 10 mph	11
647	3515	F4ML9NP	1	2	2018-01-08	0.0	30120	991225715	NY	2012-04-21	Multi Veh - Unclear Liab	Closed with Payment	1	SILVER	HEADLIGHT NOT WORKI	RX 350 AWD	2009	Automobile	Complete Front End	More than one	21-50 mph	6
650	3535	1G709MB	2	4	2018-09-19	0.0	42864	993852260	CA	2004-01-02	Multi Veh - Clear Liab	Closed with Payment	3	WHITE	FNT BMP MISALIGNED,	FUSION SE	2010	Automobile	Complete Front End	None	Below 10 mph	14
652	3555	N4DHDQ1	1	4	2013-09-14	0.0	120764	991184828	NJ	2010-03-06	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI: FRONT WHEELS F	JETTA TDI	2006	Automobile	Complete Front End	None	10-20 mph	3
674	3666	4U3D9Q9	1	4	2017-09-25	0.0	1953	998822851	SC	2005-07-11	Multi Veh - Unclear Liab	Closed without Payment	1	RED	REAR BUMPER AND TAI	GRAND CARA	2011	Automobile	Complete Rear End	None	Parked or Stopped	12
682	3701	EW5N81H	2	2	2018-08-17	0.0	3963	997999080	WA	2018-01-06	Multi Veh - Unclear Liab	Closed without Payment	1	Silver	BUMPER CAME OFF	SONATA GLS	2014	Automobile	Complete Rear End	None	Parked or Stopped	0
686	3721	RNE4JEH	1	4	2018-01-29	0.0	26549	991923166	NC	2006-09-02	Single Veh	Closed with Payment	1	BLACK	DRIVER SIDE, DRIVER	PILOT EX	2006	Automobile	Complete Driver Side	More than one	Over 50 mph	12
718	3923	ZQR3PM2	4	4	2014-09-05	0.0	100272	991077839	GA	2011-02-02	Multi Veh - Unclear Liab	Closed without Payment	1	SILVER	POI:R/E PUSHED IN F	4RUNNER LI	2003	Automobile	Complete Rear End	None	Parked or Stopped	3
773	4255	ZCOWLBC	1	4	2018-12-17	0.0	11353	998454496	PA	2015-07-21	Single Veh	Closed with Payment	1	WHITE	VEH TOTALED	CIVIC EX	2012	Automobile	All Over	More than one	Unknown	3
814	4530	VOLK8QF	2	4	2015-08-17	524.0	11349	994093298	PA	2001-12-15	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI: FRONT P/S FEND	UNKNOWN	1900	Automobile	Passenger Front Corner	Unknown	Unknown	14
877	4882	QMBUEIP	1	2	2016-01-06	0.0	292	994357837	MA	2012-06-14	Multi Veh - Unclear Liab	Closed with Payment	2	Black	POI: R/E INSD DOESN	SONATA SE/	2012	Automobile	Complete Rear End	None	Parked or Stopped	4
940	5238	WPNNFTI	1	3	2015-12-22	0.0	57691	997028763	IL	2003-08-22	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI COMPLETE FRONT	GTI	2012	Automobile	Complete Front End	More than one	21-50 mph	12
954	5320	1H0ELVZ	2	2	2016-08-27	0.0	2728	990084845	NY	2007-05-30	Multi Veh - Unclear Liab	Closed with Payment	2	Black	REAR BUMPE PUSHED D	SILVERADO	2013	Automobile	Complete Rear End	None	Below 10 mph	9
968	5370	CVBKJV0	1	2	2020-03-08	0.0	700	998412664	PA	2017-02-22	Single Veh	Closed without Payment	1	DK GRAY	NONE	TRAX LT	2017	Automobile	No Damage	None	10-20 mph	3
979	5419	QRKZUTL	1	7	2015-06-29	0.0	118041	998291048	WI	2006-05-26	Multi Veh - Unclear Liab	Closed with Payment	2	Black	POI: D/S FRONT NOT	F-150 SUPE	2009	Automobile	Driver Front Corner	None	Unknown	9
1007	5573	CMEFJTQ	3	6	2019-10-28	136.0	66938	992363323	MA	2015-12-30	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	P/S/F MIRROR RIPPED	PRIUS BASE	2009	Automobile	Complete Passenger Side	None	Unknown	4
1011	5606	GBHGEG8	1	3	2018-04-04	0.0	52454	990550037	SC	2005-05-17	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	PRIMARY POINT OF DA	IS 200T	2016	Automobile	Complete Front End	More than one	Unknown	13
1027	5687	BWGDM2Y	2	5	2019-11-15	0.0	2898	995033088	CO	2005-07-23	Multi Veh - Unclear Liab	Closed with Payment	2	GOLD	DMG TO P/S DOORS	HIGHLANDER	2001	Automobile	Passenger Center	None	Below 10 mph	14
1072	5900	VZ9MOCW	1	2	2013-05-29	5928.0	6253	999931873	KS	2000-05-22	Single Veh	Closed with Payment	2	WHITE	WINDSHIELD CAVED FT	ESCAPE LIM	2011	Automobile	Driver Front Corner	None	Unknown	13
1075	5910	7UJYDV6	1	4	2015-02-08	0.0	758	992703682	ME	2004-07-21	Multi Veh - Unclear Liab	Closed with Payment	1	Red	POI FRONT GRILL GON	COROLLA CE	2004	Automobile	Passenger Front Corner	None	10-20 mph	11
1089	5966	VKZY0T2	1	1	2014-09-02	0.0	405	996454039	MD	2004-12-09	Multi Veh - Unclear Liab	Closed with Payment	1	BLUE	POI: REAR P/S -BUMP	CR-V EX	2007	Automobile	Passenger Rear Corner	None	Parked or Stopped	10
1090	5968	39QV40S	2	3	2013-11-21	0.0	9604	997277659	PA	2011-10-31	Multi Veh - Unclear Liab	Closed with Payment	1	Silver	D/S FRT FENDER DENT	TAURUS SES	2003	Automobile	Driver Front Corner	None	Unknown	2
1163	6339	J2P3QSA	1	5	2019-07-20	0.0	37502	990602709	NH	2012-11-05	Multi Veh - Unclear Liab	Closed with Payment	4	WHITE	SMASHED IN- HOOD, F	EDGE SEL A	2013	Automobile	Passenger Front Corner	One	21-50 mph	7
1168	6361	0QEU41B	1	1	2014-09-18	28.0	7645	994603495	TN	2006-08-08	Multi Veh - Unclear Liab	Closed with Payment	1	A75-MELBOURNE	POI- PS FRONT FENDE	335	2012	Automobile	Passenger Front Corner	None	10-20 mph	8
1190	6464	88U3VJE	2	3	2018-03-23	0.0	15970	992102339	AL	2017-12-22	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE	UNK DMG	MDX	2002	Automobile	Complete Front End	Unknown	Unknown	1
1250	6768	D9WIA29	1	4	2019-07-28	905.0	3861	998866652	MD	2017-10-17	Multi Veh - Unclear Liab	Closed with Payment	3	Red	FRONT	F-150 SUPE	2016	Automobile	Complete Front End	None	21-50 mph	2
1258	6797	8CNDFHK	1	4	2019-05-03	0.0	0	993637993	DE	2013-05-28	Multi Veh - Unclear Liab	Closed without Payment	1	GRAY	P/S FRONT CORNER AN	SEDONA EX	2015	Automobile	Passenger Front Corner	None	Unknown	6
1292	7018	MO3XE2Q	1	1	2016-08-21	0.0	6308	991552776	MO	2002-10-17	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	FRT D/S FENDER AND	C300 4MATI	2012	Automobile	Driver Front Corner	None	21-50 mph	14
1316	7139	NR6LWE5	3	8	2016-10-02	0.0	38850	998069259	AZ	2005-07-08	Multi Veh - Unclear Liab	Closed without Payment	1	Beige	LEAKING FLUID WHEEL	EQUINOX LT	2010	Automobile	Driver Front Corner	None	Parked or Stopped	11
1333	7255	MUBFRNU	1	2	2015-04-24	0.0	609	994600677	FL	2003-04-10	Single Veh	Closed with Payment	1	SILVER	FRONT BUMPER CENTER	SPORTAGE B	2013	Automobile	Complete Front End	None	Below 10 mph	12
1363	7408	35QDBEJ	1	9	2015-12-31	7956.0	36435	999197878	CT	2008-03-11	Multi Veh - Unclear Liab	Closed with Payment	2	SILVER	REAR BUMPER COVER A	GRAND CARA	2006	Automobile	Complete Rear End	None	Parked or Stopped	7
1373	7493	BF9DATS	1	2	2014-05-05	0.0	0	994488298	TN	2001-11-29	Multi Veh - Unclear Liab	Closed without Payment	2	Silver	POI:REAR:MIDDLE TOW	QUEST 3.5	2006	Automobile	Complete Rear End	None	Parked or Stopped	13
1374	7501	OHXN6AS	2	2	2015-12-21	0.0	8226	999914593	CT	2014-10-31	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI F/E SMASH HOOD	626 DX/626	1997	Automobile	Driver Front Corner	None	Unknown	1
1375	7507	34ZDON6	1	5	2013-11-09	4089.0	50744	992316120	FL	2002-01-17	Multi Veh - Unclear Liab	Closed with Payment	1	RED	UNKNOWN	SIENNA XLE	2004	Automobile	Driver Center	More than one	10-20 mph	11
1378	7529	GFI3NNB	1	4	2017-11-30	0.0	21878	999785862	TX	2007-02-11	Multi Veh - Unclear Liab	Closed with Payment	5	Black	FRONT BUMPER TORN O	LS 460 L	2007	Automobile	Driver Front Corner	None	Unknown	10
1434	7859	470F6T5	1	2	2018-04-10	0.0	0	997176386	SC	2017-02-16	Multi Veh - Unclear Liab	Closed without Payment	0	RED	REAR WAS SMASHED IN	PRIUS C	2013	Automobile	Complete Rear End	None	Parked or Stopped	1
1474	8033	RA0355E	8	9	2020-03-03	0.0	37206	995826198	KY	2019-02-03	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	UNK	CENTURY BA	2005	Automobile	Complete Front End	None	Unknown	1
1482	8107	ZXDELGY	4	5	2019-03-25	0.0	60514	999437949	NY	2016-04-07	Multi Veh - Unclear Liab	Closed with Payment	2	PEWTER	SUPP FRONT DAMAGE	ODYSSEY EX	2019	Automobile	Complete Front End	More than one	Unknown	3
1483	8115	9UD570J	1	2	2016-09-22	904.0	0	999341283	NY	2004-01-01	Multi Veh - Unclear Liab	Closed without Payment	1	Red	FRONT END DAMAGES-	ECLIPSE GS	2002	Automobile	Complete Front End	More than one	21-50 mph	12
1488	8137	3DX7QMP	1	4	2015-12-17	0.0	5489	996430564	MD	2012-06-23	Multi Veh - Unclear Liab	Closed with Payment	3	BURGANDY	POI: FRONT END DMG/	SUBURBAN 1	2005	Automobile	Complete Front End	None	21-50 mph	3
1510	8274	G391JNS	1	1	2016-11-12	0.0	11459	995001733	GA	2016-11-12	Multi Veh - Unclear Liab	Closed with Payment	2	GOLD	SMASHED IN	GX 460	2015	Automobile	Complete Front End	None	Below 10 mph	0
1561	8571	8I7I5HY	2	3	2013-07-09	0.0	9065	997422221	SC	1999-08-13	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	FRONT BUMPER AND HO	FORENZA	2006	Automobile	Complete Front End	Unknown	21-50 mph	14

	Unnamed: 0	CLM_NBR	NBR_OF_CLMT	BI_CLMT_CNT	COV_RGST_DT	CLAIM_EXPENSE_EST_AMT	CLAIM_INDEMNITY_EST_AMT	POL_NBR	POLICY_STATE	PRI_BTH_DT	AUTO_ACCIDENT_DESC	CLAIMANT_STATUS	APPR_DAM_EST_REC_CNT	VEH_COLR_TXT	VEH_DAM_TXT	CLMT_VEH_MDL_NM	CLMT_VEH_YR	VEH_TYPE	VEH_PRIMARY_PT_OF_DAMAGE	AIRBAG_DEPLOYED	VEH_SPEED_AT_IMPACT	age
6	31	CBH7XVD	1	3	2018-10-15	6286.0	143767	994326201	NC	2007-02-07	Multi Veh - Unclear Liab	Closed with Payment	2	WHITE	BACK GLASS IS OUT -	SRX PREMIU	2016	Automobile	Driver Rear Corner	None	Unknown	11
13	67	A3ROXGM	1	2	2018-04-11	0.0	1985	997059601	MD	2014-12-04	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE ORCHID T	REAR BUMEPR DAMAGE.	ACCORD SPO	2015	Automobile	Complete Rear End	None	Parked or Stopped	4
73	397	9W5RIA4	2	2	2017-06-12	0.0	39454	996619094	FL	2005-09-29	Multi Veh - Unclear Liab	Closed without Payment	1	Blue	F/E BUMPER DMGS	RAM PICKUP	2006	Automobile	Complete Front End	None	Unknown	12
83	472	E5Q22PP	1	3	2018-12-09	0.0	15721	990580979	TX	2016-04-07	Multi Veh - Unclear Liab	Closed without Payment	0	WHITE	PRIMARY POINT OF DA	SILVERADO	2002	Automobile	Passenger Center	None	Below 10 mph	2
93	532	QAULVZE	4	4	2019-07-05	0.0	13660	996080647	CO	2007-02-11	Multi Veh - Unclear Liab	Closed with Payment	2	WHITE	BACK BUMPER DRAGGIN	EQUINOX LT	2017	Automobile	Complete Rear End	None	Below 10 mph	12
123	649	YB6XOCC	1	1	2018-09-20	0.0	2526	991051544	CO	2010-11-06	Multi Veh - Unclear Liab	Closed with Payment	1	SLATE	NO VISIBLE DMG	TRAVERSE 2	2011	Automobile	Complete Front End	None	Unknown	8
125	660	6QXIUBM	1	2	2016-07-02	0.0	5370	999054715	NC	2006-10-26	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	FRONT END DAMAGES-	EQUINOX LT	2005	Automobile	Complete Front End	None	21-50 mph	10
204	1040	Y6ZIY8Y	1	4	2013-12-26	0.0	4000	994120215	NC	2010-05-04	Multi Veh - Unclear Liab	Closed with Payment	1	RED	POI: P/S F LIGHT BU	ODYSSEY EX	2003	Automobile	Passenger Front Corner	More than one	21-50 mph	3
214	1088	DRSOIBW	1	6	2015-08-19	11006.0	238492	995689563	SC	2007-11-14	Multi Veh - Unclear Liab	Closed without Payment	1	UNKNOWN	POI/DMG UNKNOWN	SL2	2001	Automobile	Driver Front Corner	None	Unknown	8
237	1213	QRY6A0W	1	2	2015-05-20	0.0	232	992280160	NY	2002-12-19	Single Veh	Closed without Payment	0	SILVER	POI: NONE	SEDONA LX/	2006	Automobile	No Damage	None	Parked or Stopped	13
264	1374	SQ9T3EO	1	3	2015-02-23	0.0	8747	998698723	SC	2004-08-18	Multi Veh - Unclear Liab	Closed with Payment	1	CHARCOAL	POI: RR TRUNK PUSHE	CAMARY	2011	Automobile	Complete Rear End	None	21-50 mph	11
339	1719	07ABHRX	1	3	2017-11-08	268.0	110001	995783981	FL	2004-02-17	Multi Veh - Unclear Liab	Closed with Payment	3	BLACK CRYSTAL	DMG TO FRONT END AN	200 LIMITE	2014	Automobile	Complete Front End	None	Below 10 mph	13
341	1737	1HKW6LX	3	2	2019-12-30	0.0	10622	997696103	TX	2016-12-11	Multi Veh - Unclear Liab	Closed without Payment	0	GRAY	BUMPER BROKEN	F-150	1995	Automobile	Complete Front End	Unknown	Unknown	3
381	1948	F33UC00	1	3	2017-08-14	12289.0	20986	993709472	NY	2004-11-29	Multi Veh - Unclear Liab	Closed with Payment	2	White	R/E DMG . IV SMOKIN	CAYENNE AW	2014	Automobile	Complete Rear End	Unknown	Unknown	13
425	2174	5G8AVDW	1	1	2015-10-11	0.0	11769	992490617	TN	2015-10-12	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI: REAR CENTER BA	IMPALA	2012	Automobile	Complete Rear End	None	10-20 mph	0
428	2189	M7NZWRE	1	2	2014-10-24	0.0	4861	991288370	GA	2005-07-18	Multi Veh - Unclear Liab	Closed with Payment	1	GREEN	POI: BUMPER GRILL	CR-V LX	2002	Automobile	Complete Front End	Unknown	Unknown	9
432	2218	DN1HX4Q	2	3	2019-05-26	886.0	28937	997390124	WA	2009-06-03	Multi Veh - Unclear Liab	Closed with Payment	1	BEIGE	COMPLETE FRONT END	SIENNA LE	2011	Automobile	Complete Front End	More than one	10-20 mph	10
455	2378	3NIDUPX	2	4	2018-11-06	0.0	40965	998811319	NC	2009-10-26	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	PRIMARY POINT OF DA	MALIBU LS	2014	Automobile	Complete Front End	None	Unknown	9
466	2461	JF7Q75H	1	6	2018-11-01	0.0	3175	995417981	NC	2007-06-24	Multi Veh - Unclear Liab	Closed with Payment	2	UNKNOWN	REAR UNK	UNKNOWN	2017	Automobile	Complete Rear End	None	Parked or Stopped	11
587	3111	YJ0FH89	1	5	2016-08-18	0.0	551	993538280	MA	2008-06-21	Multi Veh - Unclear Liab	Closed with Payment	2	BLACK	CRUSHED IN PART OF	HIGHLANDER	2007	Automobile	Complete Rear End	None	Parked or Stopped	8
606	3208	4JRAL1K	3	9	2015-08-26	314.0	24032	999538731	SC	2013-06-16	Multi Veh - Unclear Liab	Closed with Payment	2	GREEN	PS FRONT WHEEL PS	CAMRY LE/C	2003	Automobile	Passenger Front Corner	None	Below 10 mph	2
640	3422	RAL8Q00	1	7	2016-03-30	90.0	35812	996422150	IL	2005-04-23	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI: ENTIRE FRONT E	MAZDA2 SPO	2013	Automobile	Complete Front End	More than one	Below 10 mph	11
647	3515	F4ML9NP	1	2	2018-01-08	0.0	30120	991225715	NY	2012-04-21	Multi Veh - Unclear Liab	Closed with Payment	1	SILVER	HEADLIGHT NOT WORKI	RX 350 AWD	2009	Automobile	Complete Front End	More than one	21-50 mph	6
652	3555	N4DHDQ1	1	4	2013-09-14	0.0	120764	991184828	NJ	2010-03-06	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI: FRONT WHEELS F	JETTA TDI	2006	Automobile	Complete Front End	None	10-20 mph	3
674	3666	4U3D9Q9	1	4	2017-09-25	0.0	1953	998822851	SC	2005-07-11	Multi Veh - Unclear Liab	Closed without Payment	1	RED	REAR BUMPER AND TAI	GRAND CARA	2011	Automobile	Complete Rear End	None	Parked or Stopped	12
682	3701	EW5N81H	2	2	2018-08-17	0.0	3963	997999080	WA	2018-01-06	Multi Veh - Unclear Liab	Closed without Payment	1	Silver	BUMPER CAME OFF	SONATA GLS	2014	Automobile	Complete Rear End	None	Parked or Stopped	0
686	3721	RNE4JEH	1	4	2018-01-29	0.0	26549	991923166	NC	2006-09-02	Single Veh	Closed with Payment	1	BLACK	DRIVER SIDE, DRIVER	PILOT EX	2006	Automobile	Complete Driver Side	More than one	Over 50 mph	12
718	3923	ZQR3PM2	4	4	2014-09-05	0.0	100272	991077839	GA	2011-02-02	Multi Veh - Unclear Liab	Closed without Payment	1	SILVER	POI:R/E PUSHED IN F	4RUNNER LI	2003	Automobile	Complete Rear End	None	Parked or Stopped	3
773	4255	ZCOWLBC	1	4	2018-12-17	0.0	11353	998454496	PA	2015-07-21	Single Veh	Closed with Payment	1	WHITE	VEH TOTALED	CIVIC EX	2012	Automobile	All Over	More than one	Unknown	3
877	4882	QMBUEIP	1	2	2016-01-06	0.0	292	994357837	MA	2012-06-14	Multi Veh - Unclear Liab	Closed with Payment	2	Black	POI: R/E INSD DOESN	SONATA SE/	2012	Automobile	Complete Rear End	None	Parked or Stopped	4
940	5238	WPNNFTI	1	3	2015-12-22	0.0	57691	997028763	IL	2003-08-22	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI COMPLETE FRONT	GTI	2012	Automobile	Complete Front End	More than one	21-50 mph	12
954	5320	1H0ELVZ	2	2	2016-08-27	0.0	2728	990084845	NY	2007-05-30	Multi Veh - Unclear Liab	Closed with Payment	2	Black	REAR BUMPE PUSHED D	SILVERADO	2013	Automobile	Complete Rear End	None	Below 10 mph	9
968	5370	CVBKJV0	1	2	2020-03-08	0.0	700	998412664	PA	2017-02-22	Single Veh	Closed without Payment	1	DK GRAY	NONE	TRAX LT	2017	Automobile	No Damage	None	10-20 mph	3
979	5419	QRKZUTL	1	7	2015-06-29	0.0	118041	998291048	WI	2006-05-26	Multi Veh - Unclear Liab	Closed with Payment	2	Black	POI: D/S FRONT NOT	F-150 SUPE	2009	Automobile	Driver Front Corner	None	Unknown	9
1007	5573	CMEFJTQ	3	6	2019-10-28	136.0	66938	992363323	MA	2015-12-30	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	P/S/F MIRROR RIPPED	PRIUS BASE	2009	Automobile	Complete Passenger Side	None	Unknown	4
1011	5606	GBHGEG8	1	3	2018-04-04	0.0	52454	990550037	SC	2005-05-17	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	PRIMARY POINT OF DA	IS 200T	2016	Automobile	Complete Front End	More than one	Unknown	13
1072	5900	VZ9MOCW	1	2	2013-05-29	5928.0	6253	999931873	KS	2000-05-22	Single Veh	Closed with Payment	2	WHITE	WINDSHIELD CAVED FT	ESCAPE LIM	2011	Automobile	Driver Front Corner	None	Unknown	13
1075	5910	7UJYDV6	1	4	2015-02-08	0.0	758	992703682	ME	2004-07-21	Multi Veh - Unclear Liab	Closed with Payment	1	Red	POI FRONT GRILL GON	COROLLA CE	2004	Automobile	Passenger Front Corner	None	10-20 mph	11
1089	5966	VKZY0T2	1	1	2014-09-02	0.0	405	996454039	MD	2004-12-09	Multi Veh - Unclear Liab	Closed with Payment	1	BLUE	POI: REAR P/S -BUMP	CR-V EX	2007	Automobile	Passenger Rear Corner	None	Parked or Stopped	10
1090	5968	39QV40S	2	3	2013-11-21	0.0	9604	997277659	PA	2011-10-31	Multi Veh - Unclear Liab	Closed with Payment	1	Silver	D/S FRT FENDER DENT	TAURUS SES	2003	Automobile	Driver Front Corner	None	Unknown	2
1163	6339	J2P3QSA	1	5	2019-07-20	0.0	37502	990602709	NH	2012-11-05	Multi Veh - Unclear Liab	Closed with Payment	4	WHITE	SMASHED IN- HOOD, F	EDGE SEL A	2013	Automobile	Passenger Front Corner	One	21-50 mph	7
1168	6361	0QEU41B	1	1	2014-09-18	28.0	7645	994603495	TN	2006-08-08	Multi Veh - Unclear Liab	Closed with Payment	1	A75-MELBOURNE	POI- PS FRONT FENDE	335	2012	Automobile	Passenger Front Corner	None	10-20 mph	8
1190	6464	88U3VJE	2	3	2018-03-23	0.0	15970	992102339	AL	2017-12-22	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE	UNK DMG	MDX	2002	Automobile	Complete Front End	Unknown	Unknown	1
1250	6768	D9WIA29	1	4	2019-07-28	905.0	3861	998866652	MD	2017-10-17	Multi Veh - Unclear Liab	Closed with Payment	3	Red	FRONT	F-150 SUPE	2016	Automobile	Complete Front End	None	21-50 mph	2
1258	6797	8CNDFHK	1	4	2019-05-03	0.0	0	993637993	DE	2013-05-28	Multi Veh - Unclear Liab	Closed without Payment	1	GRAY	P/S FRONT CORNER AN	SEDONA EX	2015	Automobile	Passenger Front Corner	None	Unknown	6
1316	7139	NR6LWE5	3	8	2016-10-02	0.0	38850	998069259	AZ	2005-07-08	Multi Veh - Unclear Liab	Closed without Payment	1	Beige	LEAKING FLUID WHEEL	EQUINOX LT	2010	Automobile	Driver Front Corner	None	Parked or Stopped	11
1333	7255	MUBFRNU	1	2	2015-04-24	0.0	609	994600677	FL	2003-04-10	Single Veh	Closed with Payment	1	SILVER	FRONT BUMPER CENTER	SPORTAGE B	2013	Automobile	Complete Front End	None	Below 10 mph	12
1363	7408	35QDBEJ	1	9	2015-12-31	7956.0	36435	999197878	CT	2008-03-11	Multi Veh - Unclear Liab	Closed with Payment	2	SILVER	REAR BUMPER COVER A	GRAND CARA	2006	Automobile	Complete Rear End	None	Parked or Stopped	7
1373	7493	BF9DATS	1	2	2014-05-05	0.0	0	994488298	TN	2001-11-29	Multi Veh - Unclear Liab	Closed without Payment	2	Silver	POI:REAR:MIDDLE TOW	QUEST 3.5	2006	Automobile	Complete Rear End	None	Parked or Stopped	13
1374	7501	OHXN6AS	2	2	2015-12-21	0.0	8226	999914593	CT	2014-10-31	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI F/E SMASH HOOD	626 DX/626	1997	Automobile	Driver Front Corner	None	Unknown	1
1375	7507	34ZDON6	1	5	2013-11-09	4089.0	50744	992316120	FL	2002-01-17	Multi Veh - Unclear Liab	Closed with Payment	1	RED	UNKNOWN	SIENNA XLE	2004	Automobile	Driver Center	More than one	10-20 mph	11
1378	7529	GFI3NNB	1	4	2017-11-30	0.0	21878	999785862	TX	2007-02-11	Multi Veh - Unclear Liab	Closed with Payment	5	Black	FRONT BUMPER TORN O	LS 460 L	2007	Automobile	Driver Front Corner	None	Unknown	10
1434	7859	470F6T5	1	2	2018-04-10	0.0	0	997176386	SC	2017-02-16	Multi Veh - Unclear Liab	Closed without Payment	0	RED	REAR WAS SMASHED IN	PRIUS C	2013	Automobile	Complete Rear End	None	Parked or Stopped	1
1474	8033	RA0355E	8	9	2020-03-03	0.0	37206	995826198	KY	2019-02-03	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	UNK	CENTURY BA	2005	Automobile	Complete Front End	None	Unknown	1
1482	8107	ZXDELGY	4	5	2019-03-25	0.0	60514	999437949	NY	2016-04-07	Multi Veh - Unclear Liab	Closed with Payment	2	PEWTER	SUPP FRONT DAMAGE	ODYSSEY EX	2019	Automobile	Complete Front End	More than one	Unknown	3
1483	8115	9UD570J	1	2	2016-09-22	904.0	0	999341283	NY	2004-01-01	Multi Veh - Unclear Liab	Closed without Payment	1	Red	FRONT END DAMAGES-	ECLIPSE GS	2002	Automobile	Complete Front End	More than one	21-50 mph	12
1488	8137	3DX7QMP	1	4	2015-12-17	0.0	5489	996430564	MD	2012-06-23	Multi Veh - Unclear Liab	Closed with Payment	3	BURGANDY	POI: FRONT END DMG/	SUBURBAN 1	2005	Automobile	Complete Front End	None	21-50 mph	3
1510	8274	G391JNS	1	1	2016-11-12	0.0	11459	995001733	GA	2016-11-12	Multi Veh - Unclear Liab	Closed with Payment	2	GOLD	SMASHED IN	GX 460	2015	Automobile	Complete Front End	None	Below 10 mph	0

	Unnamed: 0	CLM_NBR	NBR_OF_CLMT	BI_CLMT_CNT	COV_RGST_DT	CLAIM_EXPENSE_EST_AMT	CLAIM_INDEMNITY_EST_AMT	POL_NBR	POLICY_STATE	PRI_BTH_DT	AUTO_ACCIDENT_DESC	CLAIMANT_STATUS	APPR_DAM_EST_REC_CNT	VEH_COLR_TXT	VEH_DAM_TXT	CLMT_VEH_MDL_NM	CLMT_VEH_YR	VEH_TYPE	VEH_PRIMARY_PT_OF_DAMAGE	AIRBAG_DEPLOYED	VEH_SPEED_AT_IMPACT	age
13	67	A3ROXGM	1	2	2018-04-11	0.0	1985	997059601	MD	2014-12-04	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE ORCHID T	REAR BUMEPR DAMAGE.	ACCORD SPO	2015	Automobile	Complete Rear End	None	Parked or Stopped	4
73	397	9W5RIA4	2	2	2017-06-12	0.0	39454	996619094	FL	2005-09-29	Multi Veh - Unclear Liab	Closed without Payment	1	Blue	F/E BUMPER DMGS	RAM PICKUP	2006	Automobile	Complete Front End	None	Unknown	12
83	472	E5Q22PP	1	3	2018-12-09	0.0	15721	990580979	TX	2016-04-07	Multi Veh - Unclear Liab	Closed without Payment	0	WHITE	PRIMARY POINT OF DA	SILVERADO	2002	Automobile	Passenger Center	None	Below 10 mph	2
214	1088	DRSOIBW	1	6	2015-08-19	11006.0	238492	995689563	SC	2007-11-14	Multi Veh - Unclear Liab	Closed without Payment	1	UNKNOWN	POI/DMG UNKNOWN	SL2	2001	Automobile	Driver Front Corner	None	Unknown	8
237	1213	QRY6A0W	1	2	2015-05-20	0.0	232	992280160	NY	2002-12-19	Single Veh	Closed without Payment	0	SILVER	POI: NONE	SEDONA LX/	2006	Automobile	No Damage	None	Parked or Stopped	13
341	1737	1HKW6LX	3	2	2019-12-30	0.0	10622	997696103	TX	2016-12-11	Multi Veh - Unclear Liab	Closed without Payment	0	GRAY	BUMPER BROKEN	F-150	1995	Automobile	Complete Front End	Unknown	Unknown	3
674	3666	4U3D9Q9	1	4	2017-09-25	0.0	1953	998822851	SC	2005-07-11	Multi Veh - Unclear Liab	Closed without Payment	1	RED	REAR BUMPER AND TAI	GRAND CARA	2011	Automobile	Complete Rear End	None	Parked or Stopped	12
682	3701	EW5N81H	2	2	2018-08-17	0.0	3963	997999080	WA	2018-01-06	Multi Veh - Unclear Liab	Closed without Payment	1	Silver	BUMPER CAME OFF	SONATA GLS	2014	Automobile	Complete Rear End	None	Parked or Stopped	0
718	3923	ZQR3PM2	4	4	2014-09-05	0.0	100272	991077839	GA	2011-02-02	Multi Veh - Unclear Liab	Closed without Payment	1	SILVER	POI:R/E PUSHED IN F	4RUNNER LI	2003	Automobile	Complete Rear End	None	Parked or Stopped	3
968	5370	CVBKJV0	1	2	2020-03-08	0.0	700	998412664	PA	2017-02-22	Single Veh	Closed without Payment	1	DK GRAY	NONE	TRAX LT	2017	Automobile	No Damage	None	10-20 mph	3
1190	6464	88U3VJE	2	3	2018-03-23	0.0	15970	992102339	AL	2017-12-22	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE	UNK DMG	MDX	2002	Automobile	Complete Front End	Unknown	Unknown	1
1258	6797	8CNDFHK	1	4	2019-05-03	0.0	0	993637993	DE	2013-05-28	Multi Veh - Unclear Liab	Closed without Payment	1	GRAY	P/S FRONT CORNER AN	SEDONA EX	2015	Automobile	Passenger Front Corner	None	Unknown	6
1316	7139	NR6LWE5	3	8	2016-10-02	0.0	38850	998069259	AZ	2005-07-08	Multi Veh - Unclear Liab	Closed without Payment	1	Beige	LEAKING FLUID WHEEL	EQUINOX LT	2010	Automobile	Driver Front Corner	None	Parked or Stopped	11
1373	7493	BF9DATS	1	2	2014-05-05	0.0	0	994488298	TN	2001-11-29	Multi Veh - Unclear Liab	Closed without Payment	2	Silver	POI:REAR:MIDDLE TOW	QUEST 3.5	2006	Automobile	Complete Rear End	None	Parked or Stopped	13
1434	7859	470F6T5	1	2	2018-04-10	0.0	0	997176386	SC	2017-02-16	Multi Veh - Unclear Liab	Closed without Payment	0	RED	REAR WAS SMASHED IN	PRIUS C	2013	Automobile	Complete Rear End	None	Parked or Stopped	1
1483	8115	9UD570J	1	2	2016-09-22	904.0	0	999341283	NY	2004-01-01	Multi Veh - Unclear Liab	Closed without Payment	1	Red	FRONT END DAMAGES-	ECLIPSE GS	2002	Automobile	Complete Front End	More than one	21-50 mph	12

	Unnamed: 0	CLM_NBR	NBR_OF_CLMT	BI_CLMT_CNT	COV_RGST_DT	CLAIM_EXPENSE_EST_AMT	CLAIM_INDEMNITY_EST_AMT	POL_NBR	POLICY_STATE	PRI_BTH_DT	AUTO_ACCIDENT_DESC	CLAIMANT_STATUS	APPR_DAM_EST_REC_CNT	VEH_COLR_TXT	VEH_DAM_TXT	CLMT_VEH_MDL_NM	CLMT_VEH_YR	VEH_TYPE	VEH_PRIMARY_PT_OF_DAMAGE	AIRBAG_DEPLOYED	VEH_SPEED_AT_IMPACT	age
6	31	CBH7XVD	1	3	2018-10-15	6286.0	143767	994326201	NC	2007-02-07	Multi Veh - Unclear Liab	Closed with Payment	2	WHITE	BACK GLASS IS OUT -	SRX PREMIU	2016	Automobile	Driver Rear Corner	None	Unknown	11
13	67	A3ROXGM	1	2	2018-04-11	0.0	1985	997059601	MD	2014-12-04	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE ORCHID T	REAR BUMEPR DAMAGE.	ACCORD SPO	2015	Automobile	Complete Rear End	None	Parked or Stopped	4
73	397	9W5RIA4	2	2	2017-06-12	0.0	39454	996619094	FL	2005-09-29	Multi Veh - Unclear Liab	Closed without Payment	1	Blue	F/E BUMPER DMGS	RAM PICKUP	2006	Automobile	Complete Front End	None	Unknown	12
77	416	EZ27RSU	2	5	2018-08-06	2180.0	56082	993611581	FL	2004-08-21	Multi Veh - Unclear Liab	Closed with Payment	2	GOLD	HEAVY F/E DMG, FLUI	ACADIA SLT	2013	Automobile	Complete Front End	None	21-50 mph	14
83	472	E5Q22PP	1	3	2018-12-09	0.0	15721	990580979	TX	2016-04-07	Multi Veh - Unclear Liab	Closed without Payment	0	WHITE	PRIMARY POINT OF DA	SILVERADO	2002	Automobile	Passenger Center	None	Below 10 mph	2
93	532	QAULVZE	4	4	2019-07-05	0.0	13660	996080647	CO	2007-02-11	Multi Veh - Unclear Liab	Closed with Payment	2	WHITE	BACK BUMPER DRAGGIN	EQUINOX LT	2017	Automobile	Complete Rear End	None	Below 10 mph	12
123	649	YB6XOCC	1	1	2018-09-20	0.0	2526	991051544	CO	2010-11-06	Multi Veh - Unclear Liab	Closed with Payment	1	SLATE	NO VISIBLE DMG	TRAVERSE 2	2011	Automobile	Complete Front End	None	Unknown	8
125	660	6QXIUBM	1	2	2016-07-02	0.0	5370	999054715	NC	2006-10-26	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	FRONT END DAMAGES-	EQUINOX LT	2005	Automobile	Complete Front End	None	21-50 mph	10
204	1040	Y6ZIY8Y	1	4	2013-12-26	0.0	4000	994120215	NC	2010-05-04	Multi Veh - Unclear Liab	Closed with Payment	1	RED	POI: P/S F LIGHT BU	ODYSSEY EX	2003	Automobile	Passenger Front Corner	More than one	21-50 mph	3
214	1088	DRSOIBW	1	6	2015-08-19	11006.0	238492	995689563	SC	2007-11-14	Multi Veh - Unclear Liab	Closed without Payment	1	UNKNOWN	POI/DMG UNKNOWN	SL2	2001	Automobile	Driver Front Corner	None	Unknown	8
237	1213	QRY6A0W	1	2	2015-05-20	0.0	232	992280160	NY	2002-12-19	Single Veh	Closed without Payment	0	SILVER	POI: NONE	SEDONA LX/	2006	Automobile	No Damage	None	Parked or Stopped	13
264	1374	SQ9T3EO	1	3	2015-02-23	0.0	8747	998698723	SC	2004-08-18	Multi Veh - Unclear Liab	Closed with Payment	1	CHARCOAL	POI: RR TRUNK PUSHE	CAMARY	2011	Automobile	Complete Rear End	None	21-50 mph	11
339	1719	07ABHRX	1	3	2017-11-08	268.0	110001	995783981	FL	2004-02-17	Multi Veh - Unclear Liab	Closed with Payment	3	BLACK CRYSTAL	DMG TO FRONT END AN	200 LIMITE	2014	Automobile	Complete Front End	None	Below 10 mph	13
340	1725	WUKWJKF	1	4	2014-09-01	0.0	3668	992491005	SC	2000-05-27	Multi Veh - Unclear Liab	Closed with Payment	1	Silver	POI REAR BUMPER SMA	ODYSSEY EX	2010	Automobile	Complete Rear End	None	21-50 mph	14
341	1737	1HKW6LX	3	2	2019-12-30	0.0	10622	997696103	TX	2016-12-11	Multi Veh - Unclear Liab	Closed without Payment	0	GRAY	BUMPER BROKEN	F-150	1995	Automobile	Complete Front End	Unknown	Unknown	3
381	1948	F33UC00	1	3	2017-08-14	12289.0	20986	993709472	NY	2004-11-29	Multi Veh - Unclear Liab	Closed with Payment	2	White	R/E DMG . IV SMOKIN	CAYENNE AW	2014	Automobile	Complete Rear End	Unknown	Unknown	13
386	1973	RQ2PPMI	3	1	2013-11-22	0.0	21358	990788373	VA	1999-11-16	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	UNK DAMAGE	FIVE HUNDR	2005	Automobile	Driver Front Corner	One	Unknown	14
425	2174	5G8AVDW	1	1	2015-10-11	0.0	11769	992490617	TN	2015-10-12	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI: REAR CENTER BA	IMPALA	2012	Automobile	Complete Rear End	None	10-20 mph	0
428	2189	M7NZWRE	1	2	2014-10-24	0.0	4861	991288370	GA	2005-07-18	Multi Veh - Unclear Liab	Closed with Payment	1	GREEN	POI: BUMPER GRILL	CR-V LX	2002	Automobile	Complete Front End	Unknown	Unknown	9
432	2218	DN1HX4Q	2	3	2019-05-26	886.0	28937	997390124	WA	2009-06-03	Multi Veh - Unclear Liab	Closed with Payment	1	BEIGE	COMPLETE FRONT END	SIENNA LE	2011	Automobile	Complete Front End	More than one	10-20 mph	10
455	2378	3NIDUPX	2	4	2018-11-06	0.0	40965	998811319	NC	2009-10-26	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	PRIMARY POINT OF DA	MALIBU LS	2014	Automobile	Complete Front End	None	Unknown	9
466	2461	JF7Q75H	1	6	2018-11-01	0.0	3175	995417981	NC	2007-06-24	Multi Veh - Unclear Liab	Closed with Payment	2	UNKNOWN	REAR UNK	UNKNOWN	2017	Automobile	Complete Rear End	None	Parked or Stopped	11
587	3111	YJ0FH89	1	5	2016-08-18	0.0	551	993538280	MA	2008-06-21	Multi Veh - Unclear Liab	Closed with Payment	2	BLACK	CRUSHED IN PART OF	HIGHLANDER	2007	Automobile	Complete Rear End	None	Parked or Stopped	8
606	3208	4JRAL1K	3	9	2015-08-26	314.0	24032	999538731	SC	2013-06-16	Multi Veh - Unclear Liab	Closed with Payment	2	GREEN	PS FRONT WHEEL PS	CAMRY LE/C	2003	Automobile	Passenger Front Corner	None	Below 10 mph	2
640	3422	RAL8Q00	1	7	2016-03-30	90.0	35812	996422150	IL	2005-04-23	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI: ENTIRE FRONT E	MAZDA2 SPO	2013	Automobile	Complete Front End	More than one	Below 10 mph	11
647	3515	F4ML9NP	1	2	2018-01-08	0.0	30120	991225715	NY	2012-04-21	Multi Veh - Unclear Liab	Closed with Payment	1	SILVER	HEADLIGHT NOT WORKI	RX 350 AWD	2009	Automobile	Complete Front End	More than one	21-50 mph	6
650	3535	1G709MB	2	4	2018-09-19	0.0	42864	993852260	CA	2004-01-02	Multi Veh - Clear Liab	Closed with Payment	3	WHITE	FNT BMP MISALIGNED,	FUSION SE	2010	Automobile	Complete Front End	None	Below 10 mph	14
652	3555	N4DHDQ1	1	4	2013-09-14	0.0	120764	991184828	NJ	2010-03-06	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI: FRONT WHEELS F	JETTA TDI	2006	Automobile	Complete Front End	None	10-20 mph	3
674	3666	4U3D9Q9	1	4	2017-09-25	0.0	1953	998822851	SC	2005-07-11	Multi Veh - Unclear Liab	Closed without Payment	1	RED	REAR BUMPER AND TAI	GRAND CARA	2011	Automobile	Complete Rear End	None	Parked or Stopped	12
682	3701	EW5N81H	2	2	2018-08-17	0.0	3963	997999080	WA	2018-01-06	Multi Veh - Unclear Liab	Closed without Payment	1	Silver	BUMPER CAME OFF	SONATA GLS	2014	Automobile	Complete Rear End	None	Parked or Stopped	0
686	3721	RNE4JEH	1	4	2018-01-29	0.0	26549	991923166	NC	2006-09-02	Single Veh	Closed with Payment	1	BLACK	DRIVER SIDE, DRIVER	PILOT EX	2006	Automobile	Complete Driver Side	More than one	Over 50 mph	12
718	3923	ZQR3PM2	4	4	2014-09-05	0.0	100272	991077839	GA	2011-02-02	Multi Veh - Unclear Liab	Closed without Payment	1	SILVER	POI:R/E PUSHED IN F	4RUNNER LI	2003	Automobile	Complete Rear End	None	Parked or Stopped	3
773	4255	ZCOWLBC	1	4	2018-12-17	0.0	11353	998454496	PA	2015-07-21	Single Veh	Closed with Payment	1	WHITE	VEH TOTALED	CIVIC EX	2012	Automobile	All Over	More than one	Unknown	3
814	4530	VOLK8QF	2	4	2015-08-17	524.0	11349	994093298	PA	2001-12-15	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI: FRONT P/S FEND	UNKNOWN	1900	Automobile	Passenger Front Corner	Unknown	Unknown	14
877	4882	QMBUEIP	1	2	2016-01-06	0.0	292	994357837	MA	2012-06-14	Multi Veh - Unclear Liab	Closed with Payment	2	Black	POI: R/E INSD DOESN	SONATA SE/	2012	Automobile	Complete Rear End	None	Parked or Stopped	4
940	5238	WPNNFTI	1	3	2015-12-22	0.0	57691	997028763	IL	2003-08-22	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI COMPLETE FRONT	GTI	2012	Automobile	Complete Front End	More than one	21-50 mph	12
954	5320	1H0ELVZ	2	2	2016-08-27	0.0	2728	990084845	NY	2007-05-30	Multi Veh - Unclear Liab	Closed with Payment	2	Black	REAR BUMPE PUSHED D	SILVERADO	2013	Automobile	Complete Rear End	None	Below 10 mph	9
968	5370	CVBKJV0	1	2	2020-03-08	0.0	700	998412664	PA	2017-02-22	Single Veh	Closed without Payment	1	DK GRAY	NONE	TRAX LT	2017	Automobile	No Damage	None	10-20 mph	3
979	5419	QRKZUTL	1	7	2015-06-29	0.0	118041	998291048	WI	2006-05-26	Multi Veh - Unclear Liab	Closed with Payment	2	Black	POI: D/S FRONT NOT	F-150 SUPE	2009	Automobile	Driver Front Corner	None	Unknown	9
1007	5573	CMEFJTQ	3	6	2019-10-28	136.0	66938	992363323	MA	2015-12-30	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	P/S/F MIRROR RIPPED	PRIUS BASE	2009	Automobile	Complete Passenger Side	None	Unknown	4
1011	5606	GBHGEG8	1	3	2018-04-04	0.0	52454	990550037	SC	2005-05-17	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	PRIMARY POINT OF DA	IS 200T	2016	Automobile	Complete Front End	More than one	Unknown	13
1027	5687	BWGDM2Y	2	5	2019-11-15	0.0	2898	995033088	CO	2005-07-23	Multi Veh - Unclear Liab	Closed with Payment	2	GOLD	DMG TO P/S DOORS	HIGHLANDER	2001	Automobile	Passenger Center	None	Below 10 mph	14
1072	5900	VZ9MOCW	1	2	2013-05-29	5928.0	6253	999931873	KS	2000-05-22	Single Veh	Closed with Payment	2	WHITE	WINDSHIELD CAVED FT	ESCAPE LIM	2011	Automobile	Driver Front Corner	None	Unknown	13
1075	5910	7UJYDV6	1	4	2015-02-08	0.0	758	992703682	ME	2004-07-21	Multi Veh - Unclear Liab	Closed with Payment	1	Red	POI FRONT GRILL GON	COROLLA CE	2004	Automobile	Passenger Front Corner	None	10-20 mph	11
1089	5966	VKZY0T2	1	1	2014-09-02	0.0	405	996454039	MD	2004-12-09	Multi Veh - Unclear Liab	Closed with Payment	1	BLUE	POI: REAR P/S -BUMP	CR-V EX	2007	Automobile	Passenger Rear Corner	None	Parked or Stopped	10
1090	5968	39QV40S	2	3	2013-11-21	0.0	9604	997277659	PA	2011-10-31	Multi Veh - Unclear Liab	Closed with Payment	1	Silver	D/S FRT FENDER DENT	TAURUS SES	2003	Automobile	Driver Front Corner	None	Unknown	2
1163	6339	J2P3QSA	1	5	2019-07-20	0.0	37502	990602709	NH	2012-11-05	Multi Veh - Unclear Liab	Closed with Payment	4	WHITE	SMASHED IN- HOOD, F	EDGE SEL A	2013	Automobile	Passenger Front Corner	One	21-50 mph	7
1168	6361	0QEU41B	1	1	2014-09-18	28.0	7645	994603495	TN	2006-08-08	Multi Veh - Unclear Liab	Closed with Payment	1	A75-MELBOURNE	POI- PS FRONT FENDE	335	2012	Automobile	Passenger Front Corner	None	10-20 mph	8
1190	6464	88U3VJE	2	3	2018-03-23	0.0	15970	992102339	AL	2017-12-22	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE	UNK DMG	MDX	2002	Automobile	Complete Front End	Unknown	Unknown	1
1250	6768	D9WIA29	1	4	2019-07-28	905.0	3861	998866652	MD	2017-10-17	Multi Veh - Unclear Liab	Closed with Payment	3	Red	FRONT	F-150 SUPE	2016	Automobile	Complete Front End	None	21-50 mph	2
1258	6797	8CNDFHK	1	4	2019-05-03	0.0	0	993637993	DE	2013-05-28	Multi Veh - Unclear Liab	Closed without Payment	1	GRAY	P/S FRONT CORNER AN	SEDONA EX	2015	Automobile	Passenger Front Corner	None	Unknown	6
1292	7018	MO3XE2Q	1	1	2016-08-21	0.0	6308	991552776	MO	2002-10-17	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	FRT D/S FENDER AND	C300 4MATI	2012	Automobile	Driver Front Corner	None	21-50 mph	14
1316	7139	NR6LWE5	3	8	2016-10-02	0.0	38850	998069259	AZ	2005-07-08	Multi Veh - Unclear Liab	Closed without Payment	1	Beige	LEAKING FLUID WHEEL	EQUINOX LT	2010	Automobile	Driver Front Corner	None	Parked or Stopped	11
1333	7255	MUBFRNU	1	2	2015-04-24	0.0	609	994600677	FL	2003-04-10	Single Veh	Closed with Payment	1	SILVER	FRONT BUMPER CENTER	SPORTAGE B	2013	Automobile	Complete Front End	None	Below 10 mph	12
1363	7408	35QDBEJ	1	9	2015-12-31	7956.0	36435	999197878	CT	2008-03-11	Multi Veh - Unclear Liab	Closed with Payment	2	SILVER	REAR BUMPER COVER A	GRAND CARA	2006	Automobile	Complete Rear End	None	Parked or Stopped	7
1373	7493	BF9DATS	1	2	2014-05-05	0.0	0	994488298	TN	2001-11-29	Multi Veh - Unclear Liab	Closed without Payment	2	Silver	POI:REAR:MIDDLE TOW	QUEST 3.5	2006	Automobile	Complete Rear End	None	Parked or Stopped	13
1374	7501	OHXN6AS	2	2	2015-12-21	0.0	8226	999914593	CT	2014-10-31	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI F/E SMASH HOOD	626 DX/626	1997	Automobile	Driver Front Corner	None	Unknown	1
1375	7507	34ZDON6	1	5	2013-11-09	4089.0	50744	992316120	FL	2002-01-17	Multi Veh - Unclear Liab	Closed with Payment	1	RED	UNKNOWN	SIENNA XLE	2004	Automobile	Driver Center	More than one	10-20 mph	11
1378	7529	GFI3NNB	1	4	2017-11-30	0.0	21878	999785862	TX	2007-02-11	Multi Veh - Unclear Liab	Closed with Payment	5	Black	FRONT BUMPER TORN O	LS 460 L	2007	Automobile	Driver Front Corner	None	Unknown	10
1434	7859	470F6T5	1	2	2018-04-10	0.0	0	997176386	SC	2017-02-16	Multi Veh - Unclear Liab	Closed without Payment	0	RED	REAR WAS SMASHED IN	PRIUS C	2013	Automobile	Complete Rear End	None	Parked or Stopped	1
1474	8033	RA0355E	8	9	2020-03-03	0.0	37206	995826198	KY	2019-02-03	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	UNK	CENTURY BA	2005	Automobile	Complete Front End	None	Unknown	1
1482	8107	ZXDELGY	4	5	2019-03-25	0.0	60514	999437949	NY	2016-04-07	Multi Veh - Unclear Liab	Closed with Payment	2	PEWTER	SUPP FRONT DAMAGE	ODYSSEY EX	2019	Automobile	Complete Front End	More than one	Unknown	3
1483	8115	9UD570J	1	2	2016-09-22	904.0	0	999341283	NY	2004-01-01	Multi Veh - Unclear Liab	Closed without Payment	1	Red	FRONT END DAMAGES-	ECLIPSE GS	2002	Automobile	Complete Front End	More than one	21-50 mph	12
1488	8137	3DX7QMP	1	4	2015-12-17	0.0	5489	996430564	MD	2012-06-23	Multi Veh - Unclear Liab	Closed with Payment	3	BURGANDY	POI: FRONT END DMG/	SUBURBAN 1	2005	Automobile	Complete Front End	None	21-50 mph	3
1510	8274	G391JNS	1	1	2016-11-12	0.0	11459	995001733	GA	2016-11-12	Multi Veh - Unclear Liab	Closed with Payment	2	GOLD	SMASHED IN	GX 460	2015	Automobile	Complete Front End	None	Below 10 mph	0
1561	8571	8I7I5HY	2	3	2013-07-09	0.0	9065	997422221	SC	1999-08-13	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	FRONT BUMPER AND HO	FORENZA	2006	Automobile	Complete Front End	Unknown	21-50 mph	14

	Unnamed: 0	CLM_NBR	NBR_OF_CLMT	BI_CLMT_CNT	COV_RGST_DT	CLAIM_EXPENSE_EST_AMT	CLAIM_INDEMNITY_EST_AMT	POL_NBR	POLICY_STATE	PRI_BTH_DT	AUTO_ACCIDENT_DESC	CLAIMANT_STATUS	APPR_DAM_EST_REC_CNT	VEH_COLR_TXT	VEH_DAM_TXT	CLMT_VEH_MDL_NM	CLMT_VEH_YR	VEH_TYPE	VEH_PRIMARY_PT_OF_DAMAGE	AIRBAG_DEPLOYED	VEH_SPEED_AT_IMPACT	age
6	31	CBH7XVD	1	3	2018-10-15	6286.0	143767	994326201	NC	2007-02-07	Multi Veh - Unclear Liab	Closed with Payment	2	WHITE	BACK GLASS IS OUT -	SRX PREMIU	2016	Automobile	Driver Rear Corner	None	Unknown	11
13	67	A3ROXGM	1	2	2018-04-11	0.0	1985	997059601	MD	2014-12-04	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE ORCHID T	REAR BUMEPR DAMAGE.	ACCORD SPO	2015	Automobile	Complete Rear End	None	Parked or Stopped	4
73	397	9W5RIA4	2	2	2017-06-12	0.0	39454	996619094	FL	2005-09-29	Multi Veh - Unclear Liab	Closed without Payment	1	Blue	F/E BUMPER DMGS	RAM PICKUP	2006	Automobile	Complete Front End	None	Unknown	12
83	472	E5Q22PP	1	3	2018-12-09	0.0	15721	990580979	TX	2016-04-07	Multi Veh - Unclear Liab	Closed without Payment	0	WHITE	PRIMARY POINT OF DA	SILVERADO	2002	Automobile	Passenger Center	None	Below 10 mph	2
93	532	QAULVZE	4	4	2019-07-05	0.0	13660	996080647	CO	2007-02-11	Multi Veh - Unclear Liab	Closed with Payment	2	WHITE	BACK BUMPER DRAGGIN	EQUINOX LT	2017	Automobile	Complete Rear End	None	Below 10 mph	12
123	649	YB6XOCC	1	1	2018-09-20	0.0	2526	991051544	CO	2010-11-06	Multi Veh - Unclear Liab	Closed with Payment	1	SLATE	NO VISIBLE DMG	TRAVERSE 2	2011	Automobile	Complete Front End	None	Unknown	8
125	660	6QXIUBM	1	2	2016-07-02	0.0	5370	999054715	NC	2006-10-26	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	FRONT END DAMAGES-	EQUINOX LT	2005	Automobile	Complete Front End	None	21-50 mph	10
204	1040	Y6ZIY8Y	1	4	2013-12-26	0.0	4000	994120215	NC	2010-05-04	Multi Veh - Unclear Liab	Closed with Payment	1	RED	POI: P/S F LIGHT BU	ODYSSEY EX	2003	Automobile	Passenger Front Corner	More than one	21-50 mph	3
214	1088	DRSOIBW	1	6	2015-08-19	11006.0	238492	995689563	SC	2007-11-14	Multi Veh - Unclear Liab	Closed without Payment	1	UNKNOWN	POI/DMG UNKNOWN	SL2	2001	Automobile	Driver Front Corner	None	Unknown	8
237	1213	QRY6A0W	1	2	2015-05-20	0.0	232	992280160	NY	2002-12-19	Single Veh	Closed without Payment	0	SILVER	POI: NONE	SEDONA LX/	2006	Automobile	No Damage	None	Parked or Stopped	13
264	1374	SQ9T3EO	1	3	2015-02-23	0.0	8747	998698723	SC	2004-08-18	Multi Veh - Unclear Liab	Closed with Payment	1	CHARCOAL	POI: RR TRUNK PUSHE	CAMARY	2011	Automobile	Complete Rear End	None	21-50 mph	11
339	1719	07ABHRX	1	3	2017-11-08	268.0	110001	995783981	FL	2004-02-17	Multi Veh - Unclear Liab	Closed with Payment	3	BLACK CRYSTAL	DMG TO FRONT END AN	200 LIMITE	2014	Automobile	Complete Front End	None	Below 10 mph	13
341	1737	1HKW6LX	3	2	2019-12-30	0.0	10622	997696103	TX	2016-12-11	Multi Veh - Unclear Liab	Closed without Payment	0	GRAY	BUMPER BROKEN	F-150	1995	Automobile	Complete Front End	Unknown	Unknown	3
381	1948	F33UC00	1	3	2017-08-14	12289.0	20986	993709472	NY	2004-11-29	Multi Veh - Unclear Liab	Closed with Payment	2	White	R/E DMG . IV SMOKIN	CAYENNE AW	2014	Automobile	Complete Rear End	Unknown	Unknown	13
425	2174	5G8AVDW	1	1	2015-10-11	0.0	11769	992490617	TN	2015-10-12	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI: REAR CENTER BA	IMPALA	2012	Automobile	Complete Rear End	None	10-20 mph	0
428	2189	M7NZWRE	1	2	2014-10-24	0.0	4861	991288370	GA	2005-07-18	Multi Veh - Unclear Liab	Closed with Payment	1	GREEN	POI: BUMPER GRILL	CR-V LX	2002	Automobile	Complete Front End	Unknown	Unknown	9
432	2218	DN1HX4Q	2	3	2019-05-26	886.0	28937	997390124	WA	2009-06-03	Multi Veh - Unclear Liab	Closed with Payment	1	BEIGE	COMPLETE FRONT END	SIENNA LE	2011	Automobile	Complete Front End	More than one	10-20 mph	10
455	2378	3NIDUPX	2	4	2018-11-06	0.0	40965	998811319	NC	2009-10-26	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	PRIMARY POINT OF DA	MALIBU LS	2014	Automobile	Complete Front End	None	Unknown	9
466	2461	JF7Q75H	1	6	2018-11-01	0.0	3175	995417981	NC	2007-06-24	Multi Veh - Unclear Liab	Closed with Payment	2	UNKNOWN	REAR UNK	UNKNOWN	2017	Automobile	Complete Rear End	None	Parked or Stopped	11
587	3111	YJ0FH89	1	5	2016-08-18	0.0	551	993538280	MA	2008-06-21	Multi Veh - Unclear Liab	Closed with Payment	2	BLACK	CRUSHED IN PART OF	HIGHLANDER	2007	Automobile	Complete Rear End	None	Parked or Stopped	8
606	3208	4JRAL1K	3	9	2015-08-26	314.0	24032	999538731	SC	2013-06-16	Multi Veh - Unclear Liab	Closed with Payment	2	GREEN	PS FRONT WHEEL PS	CAMRY LE/C	2003	Automobile	Passenger Front Corner	None	Below 10 mph	2
640	3422	RAL8Q00	1	7	2016-03-30	90.0	35812	996422150	IL	2005-04-23	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI: ENTIRE FRONT E	MAZDA2 SPO	2013	Automobile	Complete Front End	More than one	Below 10 mph	11
647	3515	F4ML9NP	1	2	2018-01-08	0.0	30120	991225715	NY	2012-04-21	Multi Veh - Unclear Liab	Closed with Payment	1	SILVER	HEADLIGHT NOT WORKI	RX 350 AWD	2009	Automobile	Complete Front End	More than one	21-50 mph	6
652	3555	N4DHDQ1	1	4	2013-09-14	0.0	120764	991184828	NJ	2010-03-06	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI: FRONT WHEELS F	JETTA TDI	2006	Automobile	Complete Front End	None	10-20 mph	3
674	3666	4U3D9Q9	1	4	2017-09-25	0.0	1953	998822851	SC	2005-07-11	Multi Veh - Unclear Liab	Closed without Payment	1	RED	REAR BUMPER AND TAI	GRAND CARA	2011	Automobile	Complete Rear End	None	Parked or Stopped	12
682	3701	EW5N81H	2	2	2018-08-17	0.0	3963	997999080	WA	2018-01-06	Multi Veh - Unclear Liab	Closed without Payment	1	Silver	BUMPER CAME OFF	SONATA GLS	2014	Automobile	Complete Rear End	None	Parked or Stopped	0
686	3721	RNE4JEH	1	4	2018-01-29	0.0	26549	991923166	NC	2006-09-02	Single Veh	Closed with Payment	1	BLACK	DRIVER SIDE, DRIVER	PILOT EX	2006	Automobile	Complete Driver Side	More than one	Over 50 mph	12
718	3923	ZQR3PM2	4	4	2014-09-05	0.0	100272	991077839	GA	2011-02-02	Multi Veh - Unclear Liab	Closed without Payment	1	SILVER	POI:R/E PUSHED IN F	4RUNNER LI	2003	Automobile	Complete Rear End	None	Parked or Stopped	3
773	4255	ZCOWLBC	1	4	2018-12-17	0.0	11353	998454496	PA	2015-07-21	Single Veh	Closed with Payment	1	WHITE	VEH TOTALED	CIVIC EX	2012	Automobile	All Over	More than one	Unknown	3
877	4882	QMBUEIP	1	2	2016-01-06	0.0	292	994357837	MA	2012-06-14	Multi Veh - Unclear Liab	Closed with Payment	2	Black	POI: R/E INSD DOESN	SONATA SE/	2012	Automobile	Complete Rear End	None	Parked or Stopped	4
940	5238	WPNNFTI	1	3	2015-12-22	0.0	57691	997028763	IL	2003-08-22	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	POI COMPLETE FRONT	GTI	2012	Automobile	Complete Front End	More than one	21-50 mph	12
954	5320	1H0ELVZ	2	2	2016-08-27	0.0	2728	990084845	NY	2007-05-30	Multi Veh - Unclear Liab	Closed with Payment	2	Black	REAR BUMPE PUSHED D	SILVERADO	2013	Automobile	Complete Rear End	None	Below 10 mph	9
968	5370	CVBKJV0	1	2	2020-03-08	0.0	700	998412664	PA	2017-02-22	Single Veh	Closed without Payment	1	DK GRAY	NONE	TRAX LT	2017	Automobile	No Damage	None	10-20 mph	3
979	5419	QRKZUTL	1	7	2015-06-29	0.0	118041	998291048	WI	2006-05-26	Multi Veh - Unclear Liab	Closed with Payment	2	Black	POI: D/S FRONT NOT	F-150 SUPE	2009	Automobile	Driver Front Corner	None	Unknown	9
1007	5573	CMEFJTQ	3	6	2019-10-28	136.0	66938	992363323	MA	2015-12-30	Multi Veh - Unclear Liab	Closed with Payment	1	BLACK	P/S/F MIRROR RIPPED	PRIUS BASE	2009	Automobile	Complete Passenger Side	None	Unknown	4
1011	5606	GBHGEG8	1	3	2018-04-04	0.0	52454	990550037	SC	2005-05-17	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	PRIMARY POINT OF DA	IS 200T	2016	Automobile	Complete Front End	More than one	Unknown	13
1072	5900	VZ9MOCW	1	2	2013-05-29	5928.0	6253	999931873	KS	2000-05-22	Single Veh	Closed with Payment	2	WHITE	WINDSHIELD CAVED FT	ESCAPE LIM	2011	Automobile	Driver Front Corner	None	Unknown	13
1075	5910	7UJYDV6	1	4	2015-02-08	0.0	758	992703682	ME	2004-07-21	Multi Veh - Unclear Liab	Closed with Payment	1	Red	POI FRONT GRILL GON	COROLLA CE	2004	Automobile	Passenger Front Corner	None	10-20 mph	11
1089	5966	VKZY0T2	1	1	2014-09-02	0.0	405	996454039	MD	2004-12-09	Multi Veh - Unclear Liab	Closed with Payment	1	BLUE	POI: REAR P/S -BUMP	CR-V EX	2007	Automobile	Passenger Rear Corner	None	Parked or Stopped	10
1090	5968	39QV40S	2	3	2013-11-21	0.0	9604	997277659	PA	2011-10-31	Multi Veh - Unclear Liab	Closed with Payment	1	Silver	D/S FRT FENDER DENT	TAURUS SES	2003	Automobile	Driver Front Corner	None	Unknown	2
1163	6339	J2P3QSA	1	5	2019-07-20	0.0	37502	990602709	NH	2012-11-05	Multi Veh - Unclear Liab	Closed with Payment	4	WHITE	SMASHED IN- HOOD, F	EDGE SEL A	2013	Automobile	Passenger Front Corner	One	21-50 mph	7
1168	6361	0QEU41B	1	1	2014-09-18	28.0	7645	994603495	TN	2006-08-08	Multi Veh - Unclear Liab	Closed with Payment	1	A75-MELBOURNE	POI- PS FRONT FENDE	335	2012	Automobile	Passenger Front Corner	None	10-20 mph	8
1190	6464	88U3VJE	2	3	2018-03-23	0.0	15970	992102339	AL	2017-12-22	Multi Veh - Unclear Liab	Closed without Payment	1	WHITE	UNK DMG	MDX	2002	Automobile	Complete Front End	Unknown	Unknown	1
1250	6768	D9WIA29	1	4	2019-07-28	905.0	3861	998866652	MD	2017-10-17	Multi Veh - Unclear Liab	Closed with Payment	3	Red	FRONT	F-150 SUPE	2016	Automobile	Complete Front End	None	21-50 mph	2
1258	6797	8CNDFHK	1	4	2019-05-03	0.0	0	993637993	DE	2013-05-28	Multi Veh - Unclear Liab	Closed without Payment	1	GRAY	P/S FRONT CORNER AN	SEDONA EX	2015	Automobile	Passenger Front Corner	None	Unknown	6
1316	7139	NR6LWE5	3	8	2016-10-02	0.0	38850	998069259	AZ	2005-07-08	Multi Veh - Unclear Liab	Closed without Payment	1	Beige	LEAKING FLUID WHEEL	EQUINOX LT	2010	Automobile	Driver Front Corner	None	Parked or Stopped	11
1333	7255	MUBFRNU	1	2	2015-04-24	0.0	609	994600677	FL	2003-04-10	Single Veh	Closed with Payment	1	SILVER	FRONT BUMPER CENTER	SPORTAGE B	2013	Automobile	Complete Front End	None	Below 10 mph	12
1363	7408	35QDBEJ	1	9	2015-12-31	7956.0	36435	999197878	CT	2008-03-11	Multi Veh - Unclear Liab	Closed with Payment	2	SILVER	REAR BUMPER COVER A	GRAND CARA	2006	Automobile	Complete Rear End	None	Parked or Stopped	7
1373	7493	BF9DATS	1	2	2014-05-05	0.0	0	994488298	TN	2001-11-29	Multi Veh - Unclear Liab	Closed without Payment	2	Silver	POI:REAR:MIDDLE TOW	QUEST 3.5	2006	Automobile	Complete Rear End	None	Parked or Stopped	13
1374	7501	OHXN6AS	2	2	2015-12-21	0.0	8226	999914593	CT	2014-10-31	Multi Veh - Unclear Liab	Closed with Payment	1	GRAY	POI F/E SMASH HOOD	626 DX/626	1997	Automobile	Driver Front Corner	None	Unknown	1
1375	7507	34ZDON6	1	5	2013-11-09	4089.0	50744	992316120	FL	2002-01-17	Multi Veh - Unclear Liab	Closed with Payment	1	RED	UNKNOWN	SIENNA XLE	2004	Automobile	Driver Center	More than one	10-20 mph	11
1378	7529	GFI3NNB	1	4	2017-11-30	0.0	21878	999785862	TX	2007-02-11	Multi Veh - Unclear Liab	Closed with Payment	5	Black	FRONT BUMPER TORN O	LS 460 L	2007	Automobile	Driver Front Corner	None	Unknown	10
1434	7859	470F6T5	1	2	2018-04-10	0.0	0	997176386	SC	2017-02-16	Multi Veh - Unclear Liab	Closed without Payment	0	RED	REAR WAS SMASHED IN	PRIUS C	2013	Automobile	Complete Rear End	None	Parked or Stopped	1
1474	8033	RA0355E	8	9	2020-03-03	0.0	37206	995826198	KY	2019-02-03	Multi Veh - Unclear Liab	Closed with Payment	1	WHITE	UNK	CENTURY BA	2005	Automobile	Complete Front End	None	Unknown	1
1482	8107	ZXDELGY	4	5	2019-03-25	0.0	60514	999437949	NY	2016-04-07	Multi Veh - Unclear Liab	Closed with Payment	2	PEWTER	SUPP FRONT DAMAGE	ODYSSEY EX	2019	Automobile	Complete Front End	More than one	Unknown	3
1483	8115	9UD570J	1	2	2016-09-22	904.0	0	999341283	NY	2004-01-01	Multi Veh - Unclear Liab	Closed without Payment	1	Red	FRONT END DAMAGES-	ECLIPSE GS	2002	Automobile	Complete Front End	More than one	21-50 mph	12
1488	8137	3DX7QMP	1	4	2015-12-17	0.0	5489	996430564	MD	2012-06-23	Multi Veh - Unclear Liab	Closed with Payment	3	BURGANDY	POI: FRONT END DMG/	SUBURBAN 1	2005	Automobile	Complete Front End	None	21-50 mph	3
1510	8274	G391JNS	1	1	2016-11-12	0.0	11459	995001733	GA	2016-11-12	Multi Veh - Unclear Liab	Closed with Payment	2	GOLD	SMASHED IN	GX 460	2015	Automobile	Complete Front End	None	Below 10 mph	0